To Populate values to COBie Spreadsheet

The Instruction sheet consist data of Title, Version, Construction Worksheet, Region, Purpose etc.

The following table represents values populated to Contact Sheet.

Note: If the required data is not available or not applicable enter "n/a" in that particular column.

Email	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The value of the date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value is populated from the Role dropdown list under the IFC Author section in the Author tab of IFC Export dialog.
Company	The value is populated from the Name textbox under the Organization section in the Author tab of IFC Export dialog.
Phone	The value is populated from the Phone textbox under the IFC Author section in the Author tab of IFC Export dialog.
ExternalSystem	The ExternalSystem is a reference column used to link the data to external contractor or COBie data.
ExternalObject	The ExternalObject is a reference column used to link the data to external contractor or COBie data.
ExternalIdentifier	The ExternalIdentifier is a reference column used to link the data to external contractor or COBie data.
Department	The value is populated from the Name textbox under the Organization section in the Author tab of IFC Export dialog.
OrganizationCode	If the data is not applicable or not available, enter `n/a` in the column.
GivenName	The value is populated from the First Name textbox under the IFC Author section in the Author tab of IFC Export dialog.
FamilyName	The value is populated from the Last Name textbox under the IFC Author section in the Author tab of IFC Export dialog.
Street	The value is populated from the Address textbox under the Organization section in the Author tab of IFC Export dialog.
PostalBox	If the data is not applicable or not available, enter `n/a` in the column.
Town	The value is populated from the City textbox under the Organization section in the Author tab of IFC Export dialog.
StateRegion	The value is populated from the State textbox under the Organization section in the Author tab of IFC Export dialog.
PostalCode	The value is populated from the Postal Code textbox under the Organization section in the Author tab of IFC Export dialog.
Country	The value is populated from the Country textbox under the Organization section in the Author tab of IFC Export dialog.

The following table represents values populated to Facility Sheet.

Name	The Name is populated from the Floor Manager dialog.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
ProjectName	The Project Name is populated from the Floor Manager dialog.
SiteName	The Site Name is populated from the Floor manager dialog.
LinearUnits	The value is populated from the PickLists sheet in the LinearUnits column.
AreaUnits	The value is populated from the PickLists sheet in the AreaUnits column.
VolumeUnits	The value is populated from the PickLists sheet in the VolumeUnits column.
CurrencyUnit	The value is populated from the Picklists sheet.
AreaMeasurement	The value is populated from the Picklists sheet.
ExternalSystem	The ExternalSystem is a reference column used to link the data to external contractor or COBie data.
ExternalProjectObject	The ExternalProjectObject is a reference column used to link the data to external contractor or COBie data.
ExternalProjectIdentifier	The ExternalProjectIdentifier is a reference column used to link the data to external contractor or COBie data.
ExternalSiteObject	The ExternalSiteObject is a reference column used to link the data to external contractor or COBie data.
ExternalSiteIdentifier	The ExternalSiteIdentifier is a reference column used to link the data to external contractor or COBie data.
ExternalFacilityObject	The ExternalFacilityObject is a reference column used to link the data to external contractor or COBie data.
ExternalFacilityIdentifier	The ExternalFacilityIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	The value is populated from ID\|Description under Identification section in the Floor manager dialog after selecting the building.
ProjectDescription	The value of Project Description is populated from the Floor Manager dialog.
SiteDescription	The value of Site Description is populated from the Floor manager dialog.

The following table represents values populated to Floor Sheet.

Name	The value is populated from the Name column of Floor Manager dialog.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	The value is populated from ID\|Description under Identification section in the Floor manager dialog after selecting the floor.
Elevation	The value is populated from the Elevation column in the Floor Manager dialog.
Height	The value is populated from the Floor-to-Floor column in the Floor Manager dialog.

The following table represents values populated to Space Sheet.

Name	The value is populated from the Label textbox in Create Space Properties dialog.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value is populated from the drop-down list of the Classification section in the Edit Space Properties dialog.
FloorName	The value is populated from the Location\|Floor textbox under Space section in the Edit Space Properties dialog.
Description	If the data is not applicable or not available, enter `n/a` in the column.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
RoomTag	The value is populated from the RoomTag textbox under COBie_Space section in the Edit Space properties dialog.
UsableHeight	The value is populated from the Ceiling Height textbox in the Space properties dialog.
GrossArea	The value is populated from the Space properties dialog.
NetArea	The value is populated from the Space properties dialog.

The following table represents values populated to Zone Sheet.

Name	The value is populated from the IfcZones Name textbox under IfcZone section in the Edit Space properties dialog.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
SpaceNames	The value is populated from the Label textbox in Create Space properties dialog.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	The value is populated from the IfcZones Name textbox under IfcZone section in the Edit Space properties dialog.

The following table represents values populated to Type Sheet.

Name	The name of Catalog Item selected from Space properties dialog is populated in the Name column.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
Description	The value is populated from the Label textbox of the properties dialog.
AssetType	The value is populated from AssetType under COBie_Asset in the properties dialog.
Manufacturer	The value is populated from the Manufacturer \| Name under Manufacturer section of properties dialog.
ModelNumber	The value is populated from the Manufacturer \| Model No. under Manufacturer section of properties dialog .
WarrantyGuarantorParts	The value is populated from the WarrantyGuarantorParts under COBie_Warranty section of properties dialog.
WarrantyDurationParts	The value is populated from the WarrantyDurationParts under COBie_Warranty section of properties dialog.
WarrantyGuarantorLabor	The value is populated from the WarrantyGuarantorLabor under COBie_Warranty section of properties dialog.
WarrantyDurationLabor	The value is populated from the WarrantyDurationLabor under COBie_Warranty section of properties dialog.
WarrantyGuarantorUnit	The value is populated from the WarrantyGuarantorUnit under COBie_Warranty section of properties dialog.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
NominalLength	The value is populated from the NominalLength textbox under COBie_Specification section of properties dialog.
NominalWidth	The value is populated from the NominalWidth textbox under COBie_Specification section of properties dialog.
NominalHeight	The value is populated from the NominalHeight textbox under COBie_Specification section of properties dialog.
ModelReference	The value is populated from the ModelReference textbox under Pset_ManufacturerTypeInformation section of properties dialog.
Shape	The value is populated from the Shape textbox under COBie_Specification section of properties dialog.
Size	The value is populated from the Size textbox under COBie_Specification section of properties dialog.
Color	The value is populated from the Color textbox under COBie_Specification section of properties dialog.
Finish	The value is populated from the Finish textbox under COBie_Specification section of properties dialog.
Grade	The value is populated from the Grade textbox under COBie_Specification section of properties dialog.
Material	The value is populated from the Material textbox under COBie_Specification section of properties dialog.
Constituents	The value is populated from the Constituents textbox under COBie_Specification section of properties dialog.
Features	The value is populated from the Features textbox under COBie_Specification section of properties dialog.
AccessibilityPerformance	The value is populated from the AccessibilityPerformance textbox under COBie_Specification section of properties dialog.
CodePerformance	The value is populated from the CodePerformance textbox under COBie_Specification section of properties dialog.
SustainabilityPerformance	The value is populated from the SustainabilityPerformance textbox under COBie_Specification section of properties dialog.

The following table represents values populated to Component Sheet. The following is an example of Door component.

Name	The name of component is populated in the Name column.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
TypeName	The Catalog Item name is populated in the TypeName column.
Space	The value of spaces placed in the DGN is populated in the Space column.
Description	The value is populated from the ID \| Type ID textbox of Identification section of properties dialog.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
SerialNumber	The value is populated from the SerialNumber textbox under the Pset_ManufacturerOccurrence section of properties dialog.
InstallationDate	The value entered by the user in the InstallationDate textbox in the properties dialog is populated in the InstallationDate column.
WarrantyStartDate	The value entered by the user in the WarrantyStartDate textbox in the properties dialog is populated in the WarrantyStartDate column.
TagNumber	The value specified in the TagNumber textbox under the COBie_Specification section of Properties dialog is populated in the TagNumber column.
BarCode	The value is populated from the BarCode textbox under the Pset_ManufacturerOccurrence section of properties dialog.
AssetIdentifier	The value is populated from the AssetIdentifier textbox under the COBie_Specification section of properties dialog.

The following table represents values populated to System Sheet.

Name	The System Name is populated to the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value is populated from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog.
ComponentNames	The value is populated from PickList sheet.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	If the data is not applicable or not available, enter `n/a` in the column.

The following table represents values populated to Assembly Sheet.

Name	The Aggregate Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog is populated in the CreatedBy column.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
SheetName	The name of component is populated in the SheetName column.
ParentName	The value is populated from PickList sheet.
ChildNames	If the data is not applicable or not available, enter `n/a` in the column.
AssemblyType	The AssemblyType is a reference column used to link the data to external contractor or COBie data.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	If the data is not applicable or not available, enter `n/a` in the column.

The following table represents values populated to Connection Sheet.

Name	The Connection Element Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
RowName1	The name of component is populated in the RowName1 column.
RowName2	The name of component is populated in the RowName2 column.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	If the data is not applicable or not available, enter `n/a` in the column.

The following table represents values populated to Spare Sheet.

Name	The Construction Equipment Resource Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
TypeName	The value populated in the TypeName column is the name of Catalog Item selected from Properties dialog.
Suppliers	The value is populated from PickList sheet.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	Value must be provided or mention 'n/a'.
SetNumber	The value specified in the SetNumber textbox under COBie_Spare section is populated in the SetNumber column.
PartNumber	The value specified in the PartNumber textbox under COBie_Spare section is populated in the PartNumber column.

The following table represents values populated to Resource Sheet.

Name	The Construction Equipment Resource Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.

The following table represents values populated to Job Sheet.

Name	The Task Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
Status	The value is populated from PickList sheet.
TypeName	The value populated in the TypeName column is the name of Catalog Item selected from Space Properties dialog.
Description	If the data is not applicable or not available, enter `n/a` in the column.
Duration	If the data is not applicable or not available, enter `0` in the column.
DurationUnit	The value is populated from PickList sheet.
Start	If the data is not applicable or not available, enter `0` in the column.
TaskStartUnit	The value is populated from PickList sheet.
Frequency	If the data is not applicable or not available, enter `0` in the column.
FrequencyUnit	The value is populated from PickList sheet.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.

The following table represents values populated to Impact Sheet.

Name	The Property Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
ImpactType	The value is populated from PickList sheet.
ImpactStage	The value is populated from PickList sheet.
SheetName	The name of component is populated in the SheetName column.
RowName	The name of component is populated in the RowName column.
Value	If the data is not applicable or not available, enter `n/a` in the column.
ImpactUnit	The value is populated from PickList sheet.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.

The following table represents values populated to Document Sheet.

Name	The Document Information is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
ApprovalBy	The Document Information Intended Use value is populated in the ApprovalBy column.
Stage	The Document Information Scope value is populated in the Stage column.
SheetName	The name of component is populated in the SheetName column.
RowName	The name of component is populated in the RowName column.
Directory	The Document Information Location value is populated in the Directory column.
File	The Document Information Identification value is populated in the File column.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	If the data is not applicable or not available, enter `n/a` in the column.
Reference	The document information is populated in the Reference column.

The following table represents populated to Attribute Sheet.

Name	The Property Name is populated in the Name column.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
SheetName	The name of component is populated in the SheetName column.
RowName	The name of component is populated in the RowName column.
Value	All the values entered while placing components are populated in the Value column.
Unit	The unit name is populated from PickList sheet.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
Description	The Property Name is populated in the Description column.
AllowedValues	The column consists of predefined values.

The following table represents values populated to Coordinate Sheet.

Name	The Building Storey Name , Space Name or Product Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Category	The value selected from the Role drop-down under the IFC Author section in the Author tab of IFC Export dialog is populated in the Category column.
SheetName	The name of component is populated in the SheetName column.
RowName	The name of component is populated in the RowName column.
CoordinateXAxis	The value of X-Axis is populated in the CoordinateXAxis column.
CoordinateYAxis	The value of Y-Axis is populated in the CoordinateYAxis column.
CoordinateZAxis	The value of Z-Axis is populated in the CoordinateZAxis column.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.
ClockwiseRotation	The value of angle at which the component rotates clockwise is populated in the ClockwiseRotation column.
ElevationRotation	The value of angle at which the component rotates at an elevation is populated in the ElevationRotation column.
YawRotation	The value of angle at which the component rotates vertically is populated in the YawRotation column.

The following table represents values populated to Issue Sheet.

Name	The Building Storey Name , Space Name or Product Name is populated in the spreadsheet.
CreatedBy	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
CreatedOn	The date when the sheet was created and the time it was created at, is populated in the CreatedOn column.
Type	The value is populated from PickList sheet.
Risk	The value is populated from PickList sheet.
Chance	The value is populated from PickList sheet.
Impact	The value is populated from PickList sheet.
SheetName1	The name of component is populated in the SheetName1 column.
RowName1	The name of component is populated in the RowName1 column.
SheetName2	The name of component is populated in the SheetName2 column.
RowName2	The name of component is populated in the RowName2 column.
Description	If the data is not applicable or not available, enter `n/a` in the column.
Owner	The value is populated from the E-Mail textbox under the IFC Author section in the Author tab of IFC Export dialog.
Mitigation	The value of Preventive Measures is populated in the column.
ExtSystem	The ExtSystem is a reference column used to link the data to external contractor or COBie data.
ExtObject	The ExtObject is a reference column used to link the data to external contractor or COBie data.
ExtIdentifier	The ExtIdentifier is a reference column used to link the data to external contractor or COBie data.

Column Shading	Status Indicator
Yellow	Required
Orange	Reference to other sheet or pick list
Purple	External Reference
Green	If specified as required
Grey	Secondary information when preparing product data